Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
EventID (FK)(PK) | A unique, automatically assigned identifier for the Event | ID_EV | Identity | integer | |
TypeCode | Describes the subtypes of a scheduled event. Examples a data maintenance event or a physical inventory event. | TY_EV | Code4 | char(4) | |
Name | The business name of the event. | NM_EV | Name | varchar(40) | |
StoreOrHomeOfficeControlCode | A code to indicate whether the event is controlled by the store or by the home office. | CC_EV | Code2 | char(2) | |
OwnerName | Identifies who in the retailer organization owns and is responsible for the EVENT. | NM_EV_OWNR | Name | varchar(40) | |
PlanStartDateTimestamp | The planned starting time and date for an event. | TS_EV_PL_EF | EffectiveDateTime | datetime | |
PlanEndDateTimestamp | The planned time and date when the event terminates | TS_EV_PL_EP | ExpirationDateTime | datetime | |
Instruction | Free text of instructions for the Worker's that are assigned to perform this Event. | DE_INSTR | DescriptionNarrative | varchar(4000) | |